/**
 * Copyright (c) 2008 Luciano Bustos - riaevolution.com, All Rights Reserved.
 * 
 * Contact luchyx@riaevolution.com
 * See www.riaevolution.com
 *  
 * Permission is hereby granted, free of charge, to any person obtaining a copy of 
 * this software and associated documentation files (the "Software"), to deal in 
 * the Software without restriction, including without limitation the rights to
 * use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies
 * of the Software, and to permit persons to whom the Software is furnished to do
 * so, subject to the following conditions:
 * 
 * The above copyright notice and this permission notice shall be included in all 
 * copies or substantial portions of the Software.
 * 
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE. 
 * */
package  com.riaevolution.utils
{
	import mx.formatters.DateBase;
	import mx.formatters.DateFormatter;
	
	public class MSSQLDateUtil
	{
		public static var SQLFormatTime:String = "DD MMM YYYY K:NN A";
				
		public static function convert(value:*):Date {
			if (value is String) {
					//If the incoming string is blank return null
					if (value == '') return null;
					
					//español a ingles.
					value = String(value).replace("Ene","Jan");
					value = String(value).replace("Abr","Apr");
					//español a ingles.
					value = String(value).replace("Ago","Aug");
					value = String(value).replace("Dic","Dec");
					
					//Otherwise convert string from UTC to LocalTime
					var df:DateFormatter = new DateFormatter();
					df.formatString = SQLFormatTime;
					DateBase.monthNamesShort
					var date:Date = new Date(df.format(value));
					//offsetMilliseconds is the difference in Milliseconds between the users
					//local time and the time sent into this function
					var offsetMilliseconds:Number = 0;
					return new Date(date.getTime() + offsetMilliseconds);
	        	} else if (value is Date) {
					return value as Date;	
			} else return null;
		}
	}
}